IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[or_CommunicationInsert]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE dbo.[or_CommunicationInsert]
Go

CREATE  PROCEDURE  dbo.[or_CommunicationInsert] 
	@MenteeID  int,
	@MentorID  int,
	@Message  nvarchar(max),
	@SenderID  int 
AS

INSERT INTO Communication(
MenteeID, 
MentorID, 
Message, 
SenderID, 
LastModDate, 
CreatedDate 
)
VALUES (
@MenteeID, 
@MentorID, 
@Message, 
@SenderID, 
GETDATE(),
GETDATE() 
)


 